Overview
Brought to you by YData
Dataset statistics
| Number of variables | 28 |
|---|---|
| Number of observations | 28732 |
| Missing cells | 154 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 13926 |
| Duplicate rows (%) | 48.5% |
| Total size in memory | 34.9 MiB |
| Average record size in memory | 1.2 KiB |
Variable types
| Text | 13 |
|---|---|
| Categorical | 7 |
| Numeric | 8 |
| Dataset has 13926 (48.5%) duplicate rows | Duplicates |
Autoridad Ambiental is highly overall correlated with Código del Departamento and 5 other fields | High correlation |
Código del Departamento is highly overall correlated with Autoridad Ambiental and 2 other fields | High correlation |
Código del Municipio is highly overall correlated with Autoridad Ambiental and 2 other fields | High correlation |
Días de excedencias is highly overall correlated with Excedencias limite actual and 1 other fields | High correlation |
Excedencias limite actual is highly overall correlated with Días de excedencias and 1 other fields | High correlation |
Latitud is highly overall correlated with Autoridad Ambiental and 1 other fields | High correlation |
Longitud is highly overall correlated with Autoridad Ambiental and 1 other fields | High correlation |
Nombre del Departamento is highly overall correlated with Autoridad Ambiental and 5 other fields | High correlation |
Porcentaje excedencias limite actual is highly overall correlated with Días de excedencias and 1 other fields | High correlation |
Tiempo de exposición (horas) is highly overall correlated with Variable | High correlation |
Tipo de Estación is highly overall correlated with Autoridad Ambiental and 1 other fields | High correlation |
Unidades is highly overall correlated with Variable | High correlation |
Variable is highly overall correlated with Tiempo de exposición (horas) and 1 other fields | High correlation |
Tipo de Estación is highly imbalanced (52.2%) | Imbalance |
Excedencias limite actual has 23462 (81.7%) zeros | Zeros |
Porcentaje excedencias limite actual has 23464 (81.7%) zeros | Zeros |
Días de excedencias has 23464 (81.7%) zeros | Zeros |
Reproduction
| Analysis started | 2025-11-09 03:50:59.013413 |
|---|---|
| Analysis finished | 2025-11-09 03:51:06.181661 |
| Duration | 7.17 seconds |
| Software version | ydata-profiling vv4.17.0 |
| Download configuration | config.json |
Variables
ID Estacion
Text
| Distinct | 501 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 MiB |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.615655 |
| Min length | 5 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 9,020 |
|---|---|
| 2nd row | 9,020 |
| 3rd row | 9,020 |
| 4th row | 9,020 |
| 5th row | 9,020 |
| Value | Count | Frequency (%) |
| 99,999 | 1176 | 4.1% |
| 8,214 | 528 | 1.8% |
| 8,213 | 526 | 1.8% |
| 8,219 | 500 | 1.7% |
| 8,208 | 481 | 1.7% |
| 8,218 | 474 | 1.6% |
| 8,211 | 466 | 1.6% |
| 8,216 | 458 | 1.6% |
| 28,202 | 418 | 1.5% |
| 9,023 | 403 | 1.4% |
| Other values (491) | 23302 |
Most occurring characters
| Value | Count | Frequency (%) |
| , | 28732 | |
| 1 | 20518 | |
| 8 | 19867 | |
| 3 | 18985 | |
| 2 | 18449 | |
| 9 | 17421 | |
| 0 | 14093 | |
| 5 | 6731 | 4.2% |
| 4 | 5689 | 3.5% |
| 6 | 5446 | 3.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 161349 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| , | 28732 | |
| 1 | 20518 | |
| 8 | 19867 | |
| 3 | 18985 | |
| 2 | 18449 | |
| 9 | 17421 | |
| 0 | 14093 | |
| 5 | 6731 | 4.2% |
| 4 | 5689 | 3.5% |
| 6 | 5446 | 3.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 161349 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| , | 28732 | |
| 1 | 20518 | |
| 8 | 19867 | |
| 3 | 18985 | |
| 2 | 18449 | |
| 9 | 17421 | |
| 0 | 14093 | |
| 5 | 6731 | 4.2% |
| 4 | 5689 | 3.5% |
| 6 | 5446 | 3.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 161349 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| , | 28732 | |
| 1 | 20518 | |
| 8 | 19867 | |
| 3 | 18985 | |
| 2 | 18449 | |
| 9 | 17421 | |
| 0 | 14093 | |
| 5 | 6731 | 4.2% |
| 4 | 5689 | 3.5% |
| 6 | 5446 | 3.4% |
Autoridad Ambiental
Categorical
High correlation
| Distinct | 30 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 MiB |
| SDA | |
|---|---|
| AMVA | |
| CORANTIOQUIA | |
| DAGMA | |
| CAR | |
| Other values (25) |
Length
| Max length | 23 |
|---|---|
| Median length | 16 |
| Mean length | 6.0719407 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | AMVA |
|---|---|
| 2nd row | AMVA |
| 3rd row | AMVA |
| 4th row | AMVA |
| 5th row | AMVA |
Common Values
| Value | Count | Frequency (%) |
| SDA | 6042 | |
| AMVA | 5703 | |
| CORANTIOQUIA | 2402 | 8.4% |
| DAGMA | 2028 | 7.1% |
| CAR | 1931 | 6.7% |
| CORPOBOYACA | 1521 | 5.3% |
| CDMB | 1418 | 4.9% |
| CORPOCESAR | 1072 | 3.7% |
| CORPAMAG | 1016 | 3.5% |
| CVC | 908 | 3.2% |
| Other values (20) | 4691 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| sda | 6042 | |
| amva | 5703 | |
| corantioquia | 2402 | 8.0% |
| dagma | 2028 | 6.8% |
| car | 1987 | 6.6% |
| corpoboyaca | 1521 | 5.1% |
| cdmb | 1418 | 4.7% |
| corpocesar | 1072 | 3.6% |
| corpamag | 1016 | 3.4% |
| epa | 981 | 3.3% |
| Other values (22) | 5767 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 43027 | |
| C | 18279 | |
| O | 16411 | 9.4% |
| R | 15778 | 9.0% |
| M | 11309 | 6.5% |
| D | 10048 | 5.8% |
| S | 7510 | 4.3% |
| V | 6799 | 3.9% |
| I | 6678 | 3.8% |
| P | 5795 | 3.3% |
| Other values (20) | 32825 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 174459 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 43027 | |
| C | 18279 | |
| O | 16411 | 9.4% |
| R | 15778 | 9.0% |
| M | 11309 | 6.5% |
| D | 10048 | 5.8% |
| S | 7510 | 4.3% |
| V | 6799 | 3.9% |
| I | 6678 | 3.8% |
| P | 5795 | 3.3% |
| Other values (20) | 32825 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 174459 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 43027 | |
| C | 18279 | |
| O | 16411 | 9.4% |
| R | 15778 | 9.0% |
| M | 11309 | 6.5% |
| D | 10048 | 5.8% |
| S | 7510 | 4.3% |
| V | 6799 | 3.9% |
| I | 6678 | 3.8% |
| P | 5795 | 3.3% |
| Other values (20) | 32825 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 174459 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 43027 | |
| C | 18279 | |
| O | 16411 | 9.4% |
| R | 15778 | 9.0% |
| M | 11309 | 6.5% |
| D | 10048 | 5.8% |
| S | 7510 | 4.3% |
| V | 6799 | 3.9% |
| I | 6678 | 3.8% |
| P | 5795 | 3.3% |
| Other values (20) | 32825 |
Estación
Text
| Distinct | 637 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.9 MiB |
Length
| Max length | 54 |
|---|---|
| Median length | 30 |
| Mean length | 12.224523 |
| Min length | 3 |
Unique
| Unique | 35 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | I.E. COL. COLOMBIA |
|---|---|
| 2nd row | I.E. COL. COLOMBIA |
| 3rd row | I.E. COL. COLOMBIA |
| 4th row | I.E. COL. COLOMBIA |
| 5th row | I.E. COL. COLOMBIA |
| Value | Count | Frequency (%) |
| la | 1752 | 3.2% |
| ca | 1258 | 2.3% |
| 1206 | 2.2% | |
| san | 1117 | 2.0% |
| u | 918 | 1.7% |
| centro | 835 | 1.5% |
| i.e | 826 | 1.5% |
| el | 818 | 1.5% |
| las | 796 | 1.4% |
| estación | 719 | 1.3% |
| Other values (593) | 45029 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 48599 | |
| 26542 | 7.6% | |
| E | 25628 | 7.3% |
| I | 22946 | 6.5% |
| O | 22514 | 6.4% |
| N | 21529 | 6.1% |
| L | 21326 | 6.1% |
| R | 21033 | 6.0% |
| C | 20264 | 5.8% |
| T | 15510 | 4.4% |
| Other values (51) | 105344 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 351235 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 48599 | |
| 26542 | 7.6% | |
| E | 25628 | 7.3% |
| I | 22946 | 6.5% |
| O | 22514 | 6.4% |
| N | 21529 | 6.1% |
| L | 21326 | 6.1% |
| R | 21033 | 6.0% |
| C | 20264 | 5.8% |
| T | 15510 | 4.4% |
| Other values (51) | 105344 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 351235 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 48599 | |
| 26542 | 7.6% | |
| E | 25628 | 7.3% |
| I | 22946 | 6.5% |
| O | 22514 | 6.4% |
| N | 21529 | 6.1% |
| L | 21326 | 6.1% |
| R | 21033 | 6.0% |
| C | 20264 | 5.8% |
| T | 15510 | 4.4% |
| Other values (51) | 105344 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 351235 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 48599 | |
| 26542 | 7.6% | |
| E | 25628 | 7.3% |
| I | 22946 | 6.5% |
| O | 22514 | 6.4% |
| N | 21529 | 6.1% |
| L | 21326 | 6.1% |
| R | 21033 | 6.0% |
| C | 20264 | 5.8% |
| T | 15510 | 4.4% |
| Other values (51) | 105344 |
Latitud
Real number (ℝ)
High correlation
| Distinct | 599 |
|---|---|
| Distinct (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.1043421 |
| Minimum | 1.216489 |
|---|---|
| Maximum | 12.23 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 224.6 KiB |
Quantile statistics
| Minimum | 1.216489 |
|---|---|
| 5-th percentile | 3.42826 |
| Q1 | 4.631767 |
| median | 6.059036 |
| Q3 | 6.4625 |
| 95-th percentile | 11.0149 |
| Maximum | 12.23 |
| Range | 11.013511 |
| Interquartile range (IQR) | 1.830733 |
Descriptive statistics
| Standard deviation | 2.1472782 |
|---|---|
| Coefficient of variation (CV) | 0.35176243 |
| Kurtosis | 0.53461037 |
| Mean | 6.1043421 |
| Median Absolute Deviation (MAD) | 1.325762 |
| Skewness | 1.0745289 |
| Sum | 175389.96 |
| Variance | 4.6108038 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4.62505 | 528 | 1.8% |
| 4.658467 | 526 | 1.8% |
| 4.6907 | 481 | 1.7% |
| 4.595617 | 474 | 1.6% |
| 4.631767 | 458 | 1.6% |
| 6.211806 | 419 | 1.5% |
| 4.576283 | 368 | 1.3% |
| 6.330697 | 363 | 1.3% |
| 4.71035 | 336 | 1.2% |
| 4.783733 | 324 | 1.1% |
| Other values (589) | 24455 |
| Value | Count | Frequency (%) |
| 1.216489 | 6 | < 0.1% |
| 1.223796 | 16 | 0.1% |
| 2.438055 | 4 | < 0.1% |
| 2.445161 | 34 | 0.1% |
| 2.476861 | 105 | |
| 2.928891 | 7 | < 0.1% |
| 2.930587778 | 2 | < 0.1% |
| 2.930678 | 12 | < 0.1% |
| 2.9625 | 22 | 0.1% |
| 2.962503 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 12.23 | 36 | 0.1% |
| 11.5475 | 2 | < 0.1% |
| 11.546889 | 78 | |
| 11.5468 | 2 | < 0.1% |
| 11.5119 | 2 | < 0.1% |
| 11.276619 | 136 | |
| 11.276492 | 118 | |
| 11.252639 | 15 | 0.1% |
| 11.250804 | 12 | < 0.1% |
| 11.240446 | 12 | < 0.1% |
Longitud
Real number (ℝ)
High correlation
| Distinct | 596 |
|---|---|
| Distinct (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -74.658257 |
| Minimum | -77.283628 |
|---|---|
| Maximum | -70.743889 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 28732 |
| Negative (%) | 100.0% |
| Memory size | 224.6 KiB |
Quantile statistics
| Minimum | -77.283628 |
|---|---|
| 5-th percentile | -76.521225 |
| Q1 | -75.581111 |
| median | -74.222547 |
| Q3 | -74.030417 |
| 95-th percentile | -72.906131 |
| Maximum | -70.743889 |
| Range | 6.5397391 |
| Interquartile range (IQR) | 1.550694 |
Descriptive statistics
| Standard deviation | 1.1331777 |
|---|---|
| Coefficient of variation (CV) | -0.015178196 |
| Kurtosis | -0.9908685 |
| Mean | -74.658257 |
| Median Absolute Deviation (MAD) | 1.1460635 |
| Skewness | 0.022725351 |
| Sum | -2145081 |
| Variance | 1.2840916 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -74.083967 | 638 | 2.2% |
| -74.161333 | 528 | 1.8% |
| -74.082483 | 481 | 1.7% |
| -74.148583 | 474 | 1.6% |
| -74.117483 | 458 | 1.6% |
| -75.581111 | 447 | 1.6% |
| -74.130967 | 368 | 1.3% |
| -75.568669 | 363 | 1.3% |
| -74.030417 | 336 | 1.2% |
| -74.043783 | 324 | 1.1% |
| Other values (586) | 24315 |
| Value | Count | Frequency (%) |
| -77.283628 | 16 | 0.1% |
| -77.282944 | 6 | < 0.1% |
| -77.068972 | 6 | < 0.1% |
| -76.646111 | 12 | < 0.1% |
| -76.61305 | 4 | < 0.1% |
| -76.605444 | 34 | 0.1% |
| -76.566734 | 105 | |
| -76.549613 | 120 | |
| -76.549347 | 94 | |
| -76.54425 | 80 |
| Value | Count | Frequency (%) |
| -70.7438889 | 4 | < 0.1% |
| -70.7575 | 18 | |
| -70.7577778 | 4 | < 0.1% |
| -70.7613889 | 4 | < 0.1% |
| -72.03 | 36 | |
| -72.385556 | 22 | |
| -72.3877778 | 4 | < 0.1% |
| -72.3905556 | 4 | < 0.1% |
| -72.4036111 | 4 | < 0.1% |
| -72.4055556 | 4 | < 0.1% |
Variable
Categorical
High correlation
| Distinct | 20 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 MiB |
| PM10 | |
|---|---|
| PM2.5 | |
| VViento | |
| DViento | |
| PLiquida | |
| Other values (15) |
Length
| Max length | 8 |
|---|---|
| Median length | 6 |
| Mean length | 4.8802729 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | DViento |
|---|---|
| 2nd row | DViento |
| 3rd row | PLiquida |
| 4th row | P |
| 5th row | P |
Common Values
| Value | Count | Frequency (%) |
| PM10 | 5138 | |
| PM2.5 | 3158 | |
| VViento | 2508 | |
| DViento | 2198 | 7.7% |
| PLiquida | 1854 | 6.5% |
| SO2 | 1758 | 6.1% |
| TAire2 | 1668 | 5.8% |
| O3 | 1481 | 5.2% |
| HAire2 | 1386 | 4.8% |
| P | 1346 | 4.7% |
| Other values (10) | 6237 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| pm10 | 5138 | |
| pm2.5 | 3158 | |
| vviento | 2508 | |
| dviento | 2198 | 7.7% |
| pliquida | 1854 | 6.5% |
| so2 | 1758 | 6.1% |
| taire2 | 1668 | 5.8% |
| o3 | 1481 | 5.2% |
| haire2 | 1386 | 4.8% |
| p | 1346 | 4.7% |
| Other values (10) | 6237 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 13154 | 9.4% |
| P | 11978 | 8.5% |
| e | 9446 | 6.7% |
| 2 | 9110 | 6.5% |
| M | 8296 | 5.9% |
| V | 7346 | 5.2% |
| 0 | 6528 | 4.7% |
| 1 | 6528 | 4.7% |
| O | 5976 | 4.3% |
| o | 5906 | 4.2% |
| Other values (23) | 55952 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 140220 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 13154 | 9.4% |
| P | 11978 | 8.5% |
| e | 9446 | 6.7% |
| 2 | 9110 | 6.5% |
| M | 8296 | 5.9% |
| V | 7346 | 5.2% |
| 0 | 6528 | 4.7% |
| 1 | 6528 | 4.7% |
| O | 5976 | 4.3% |
| o | 5906 | 4.2% |
| Other values (23) | 55952 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 140220 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 13154 | 9.4% |
| P | 11978 | 8.5% |
| e | 9446 | 6.7% |
| 2 | 9110 | 6.5% |
| M | 8296 | 5.9% |
| V | 7346 | 5.2% |
| 0 | 6528 | 4.7% |
| 1 | 6528 | 4.7% |
| O | 5976 | 4.3% |
| o | 5906 | 4.2% |
| Other values (23) | 55952 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 140220 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 13154 | 9.4% |
| P | 11978 | 8.5% |
| e | 9446 | 6.7% |
| 2 | 9110 | 6.5% |
| M | 8296 | 5.9% |
| V | 7346 | 5.2% |
| 0 | 6528 | 4.7% |
| 1 | 6528 | 4.7% |
| O | 5976 | 4.3% |
| o | 5906 | 4.2% |
| Other values (23) | 55952 |
Unidades
Categorical
High correlation
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| ugm3 | |
|---|---|
| ms | |
| Celsius | |
| perc | |
| deg | |
| Other values (4) |
Length
| Max length | 7 |
|---|---|
| Median length | 4 |
| Mean length | 3.8372546 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | deg |
|---|---|
| 2nd row | deg |
| 3rd row | mm |
| 4th row | mmHg |
| 5th row | mmHg |
Common Values
| Value | Count | Frequency (%) |
| ugm3 | 14754 | |
| ms | 2508 | 8.7% |
| Celsius | 2482 | 8.6% |
| perc | 2258 | 7.9% |
| deg | 2198 | 7.7% |
| mm | 1854 | 6.5% |
| mmHg | 1346 | 4.7% |
| Wm2 | 1200 | 4.2% |
| MEDh | 132 | 0.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| ugm3 | 14754 | |
| ms | 2508 | 8.7% |
| celsius | 2482 | 8.6% |
| perc | 2258 | 7.9% |
| deg | 2198 | 7.7% |
| mm | 1854 | 6.5% |
| mmhg | 1346 | 4.7% |
| wm2 | 1200 | 4.2% |
| medh | 132 | 0.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| m | 24862 | |
| g | 18298 | |
| u | 17236 | |
| 3 | 14754 | |
| s | 7472 | 6.8% |
| e | 6938 | 6.3% |
| C | 2482 | 2.3% |
| l | 2482 | 2.3% |
| i | 2482 | 2.3% |
| p | 2258 | 2.0% |
| Other values (10) | 10988 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 110252 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| m | 24862 | |
| g | 18298 | |
| u | 17236 | |
| 3 | 14754 | |
| s | 7472 | 6.8% |
| e | 6938 | 6.3% |
| C | 2482 | 2.3% |
| l | 2482 | 2.3% |
| i | 2482 | 2.3% |
| p | 2258 | 2.0% |
| Other values (10) | 10988 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 110252 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| m | 24862 | |
| g | 18298 | |
| u | 17236 | |
| 3 | 14754 | |
| s | 7472 | 6.8% |
| e | 6938 | 6.3% |
| C | 2482 | 2.3% |
| l | 2482 | 2.3% |
| i | 2482 | 2.3% |
| p | 2258 | 2.0% |
| Other values (10) | 10988 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 110252 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| m | 24862 | |
| g | 18298 | |
| u | 17236 | |
| 3 | 14754 | |
| s | 7472 | 6.8% |
| e | 6938 | 6.3% |
| C | 2482 | 2.3% |
| l | 2482 | 2.3% |
| i | 2482 | 2.3% |
| p | 2258 | 2.0% |
| Other values (10) | 10988 |
Tiempo de exposición (horas)
Categorical
High correlation
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 24 | |
|---|---|
| 1 | |
| 8 | |
| 3 | 210 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 1.5183767 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 24 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 24 |
Common Values
| Value | Count | Frequency (%) |
| 24 | 14894 | |
| 1 | 12036 | |
| 8 | 1592 | 5.5% |
| 3 | 210 | 0.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 24 | 14894 | |
| 1 | 12036 | |
| 8 | 1592 | 5.5% |
| 3 | 210 | 0.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 14894 | |
| 4 | 14894 | |
| 1 | 12036 | |
| 8 | 1592 | 3.6% |
| 3 | 210 | 0.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 43626 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 14894 | |
| 4 | 14894 | |
| 1 | 12036 | |
| 8 | 1592 | 3.6% |
| 3 | 210 | 0.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 43626 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 14894 | |
| 4 | 14894 | |
| 1 | 12036 | |
| 8 | 1592 | 3.6% |
| 3 | 210 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 43626 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 14894 | |
| 4 | 14894 | |
| 1 | 12036 | |
| 8 | 1592 | 3.6% |
| 3 | 210 | 0.5% |
Año
Categorical
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 MiB |
| 2,022 | |
|---|---|
| 2,021 | |
| 2,020 | |
| 2,017 | |
| 2,018 | |
| Other values (8) |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2,011 |
|---|---|
| 2nd row | 2,011 |
| 3rd row | 2,011 |
| 4th row | 2,011 |
| 5th row | 2,011 |
Common Values
| Value | Count | Frequency (%) |
| 2,022 | 3882 | |
| 2,021 | 3720 | |
| 2,020 | 3196 | |
| 2,017 | 2705 | |
| 2,018 | 2310 | |
| 2,016 | 1932 | |
| 2,019 | 1864 | |
| 2,013 | 1824 | |
| 2,015 | 1806 | |
| 2,014 | 1728 | |
| Other values (3) | 3765 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 2,022 | 3882 | |
| 2,021 | 3720 | |
| 2,020 | 3196 | |
| 2,017 | 2705 | |
| 2,018 | 2310 | |
| 2,016 | 1932 | |
| 2,019 | 1864 | |
| 2,013 | 1824 | |
| 2,015 | 1806 | |
| 2,014 | 1728 | |
| Other values (3) | 3765 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 45883 | |
| 0 | 31928 | |
| , | 28732 | |
| 1 | 22095 | |
| 7 | 2705 | 1.9% |
| 3 | 2677 | 1.9% |
| 8 | 2310 | 1.6% |
| 6 | 1932 | 1.3% |
| 9 | 1864 | 1.3% |
| 5 | 1806 | 1.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 143660 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 45883 | |
| 0 | 31928 | |
| , | 28732 | |
| 1 | 22095 | |
| 7 | 2705 | 1.9% |
| 3 | 2677 | 1.9% |
| 8 | 2310 | 1.6% |
| 6 | 1932 | 1.3% |
| 9 | 1864 | 1.3% |
| 5 | 1806 | 1.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 143660 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 45883 | |
| 0 | 31928 | |
| , | 28732 | |
| 1 | 22095 | |
| 7 | 2705 | 1.9% |
| 3 | 2677 | 1.9% |
| 8 | 2310 | 1.6% |
| 6 | 1932 | 1.3% |
| 9 | 1864 | 1.3% |
| 5 | 1806 | 1.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 143660 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 45883 | |
| 0 | 31928 | |
| , | 28732 | |
| 1 | 22095 | |
| 7 | 2705 | 1.9% |
| 3 | 2677 | 1.9% |
| 8 | 2310 | 1.6% |
| 6 | 1932 | 1.3% |
| 9 | 1864 | 1.3% |
| 5 | 1806 | 1.3% |
Promedio
Text
| Distinct | 2823 |
|---|---|
| Distinct (%) | 9.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
Length
| Max length | 8 |
|---|---|
| Median length | 4 |
| Mean length | 3.7667061 |
| Min length | 1 |
Unique
| Unique | 68 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | 256.8 |
|---|---|
| 2nd row | 257.4 |
| 3rd row | 4 |
| 4th row | 645.9 |
| 5th row | 645.9 |
| Value | Count | Frequency (%) |
| 0.1 | 475 | 1.7% |
| 1 | 364 | 1.3% |
| 1.4 | 218 | 0.8% |
| 0.2 | 209 | 0.7% |
| 1.2 | 184 | 0.6% |
| 1.1 | 180 | 0.6% |
| 0.9 | 177 | 0.6% |
| 0.8 | 174 | 0.6% |
| 0.6 | 154 | 0.5% |
| 1.3 | 150 | 0.5% |
| Other values (2813) | 26447 |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 25500 | |
| 1 | 13929 | |
| 2 | 12205 | |
| 3 | 9465 | 8.7% |
| 4 | 7800 | 7.2% |
| 6 | 7633 | 7.1% |
| 5 | 7328 | 6.8% |
| 7 | 7165 | 6.6% |
| 8 | 6599 | 6.1% |
| 9 | 5556 | 5.1% |
| Other values (2) | 5045 | 4.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 108225 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| . | 25500 | |
| 1 | 13929 | |
| 2 | 12205 | |
| 3 | 9465 | 8.7% |
| 4 | 7800 | 7.2% |
| 6 | 7633 | 7.1% |
| 5 | 7328 | 6.8% |
| 7 | 7165 | 6.6% |
| 8 | 6599 | 6.1% |
| 9 | 5556 | 5.1% |
| Other values (2) | 5045 | 4.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 108225 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| . | 25500 | |
| 1 | 13929 | |
| 2 | 12205 | |
| 3 | 9465 | 8.7% |
| 4 | 7800 | 7.2% |
| 6 | 7633 | 7.1% |
| 5 | 7328 | 6.8% |
| 7 | 7165 | 6.6% |
| 8 | 6599 | 6.1% |
| 9 | 5556 | 5.1% |
| Other values (2) | 5045 | 4.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 108225 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| . | 25500 | |
| 1 | 13929 | |
| 2 | 12205 | |
| 3 | 9465 | 8.7% |
| 4 | 7800 | 7.2% |
| 6 | 7633 | 7.1% |
| 5 | 7328 | 6.8% |
| 7 | 7165 | 6.6% |
| 8 | 6599 | 6.1% |
| 9 | 5556 | 5.1% |
| Other values (2) | 5045 | 4.7% |
Suma
Text
| Distinct | 14463 |
|---|---|
| Distinct (%) | 50.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.6 MiB |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 8.3828136 |
| Min length | 1 |
Unique
| Unique | 849 ? |
|---|---|
| Unique (%) | 3.0% |
Sample
| 1st row | 321,637.5091 |
|---|---|
| 2nd row | 14,984.01 |
| 3rd row | 293.5 |
| 4th row | 2,917,013.928 |
| 5th row | 121,434.69 |
| Value | Count | Frequency (%) |
| 47 | 108 | 0.4% |
| 2 | 54 | 0.2% |
| 105.02 | 8 | < 0.1% |
| 120.4 | 8 | < 0.1% |
| 968.8 | 6 | < 0.1% |
| 852.4 | 6 | < 0.1% |
| 2.8 | 6 | < 0.1% |
| 1,072.8 | 6 | < 0.1% |
| 22,985.52 | 6 | < 0.1% |
| 12.99 | 6 | < 0.1% |
| Other values (14453) | 28518 |
Most occurring characters
| Value | Count | Frequency (%) |
| , | 26808 | |
| . | 25847 | |
| 1 | 25142 | |
| 2 | 21770 | |
| 3 | 19469 | |
| 5 | 19076 | |
| 4 | 18710 | |
| 6 | 18211 | |
| 7 | 17892 | |
| 8 | 17267 | |
| Other values (2) | 30663 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 240855 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| , | 26808 | |
| . | 25847 | |
| 1 | 25142 | |
| 2 | 21770 | |
| 3 | 19469 | |
| 5 | 19076 | |
| 4 | 18710 | |
| 6 | 18211 | |
| 7 | 17892 | |
| 8 | 17267 | |
| Other values (2) | 30663 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 240855 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| , | 26808 | |
| . | 25847 | |
| 1 | 25142 | |
| 2 | 21770 | |
| 3 | 19469 | |
| 5 | 19076 | |
| 4 | 18710 | |
| 6 | 18211 | |
| 7 | 17892 | |
| 8 | 17267 | |
| Other values (2) | 30663 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 240855 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| , | 26808 | |
| . | 25847 | |
| 1 | 25142 | |
| 2 | 21770 | |
| 3 | 19469 | |
| 5 | 19076 | |
| 4 | 18710 | |
| 6 | 18211 | |
| 7 | 17892 | |
| 8 | 17267 | |
| Other values (2) | 30663 |
No. de datos
Text
| Distinct | 3821 |
|---|---|
| Distinct (%) | 13.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
Length
| Max length | 5 |
|---|---|
| Median length | 3 |
| Mean length | 3.7057288 |
| Min length | 1 |
Unique
| Unique | 160 ? |
|---|---|
| Unique (%) | 0.6% |
Sample
| 1st row | 1,411 |
|---|---|
| 2nd row | 59 |
| 3rd row | 74 |
| 4th row | 4,516 |
| 5th row | 188 |
| Value | Count | Frequency (%) |
| 365 | 375 | 1.3% |
| 31 | 274 | 1.0% |
| 364 | 266 | 0.9% |
| 363 | 244 | 0.8% |
| 361 | 187 | 0.7% |
| 20 | 167 | 0.6% |
| 355 | 160 | 0.6% |
| 352 | 155 | 0.5% |
| 359 | 154 | 0.5% |
| 360 | 143 | 0.5% |
| Other values (3811) | 26607 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 13650 | |
| , | 12720 | |
| 1 | 11287 | |
| 8 | 10494 | |
| 2 | 10039 | |
| 7 | 9655 | |
| 5 | 9170 | |
| 6 | 9095 | |
| 4 | 8427 | |
| 0 | 6197 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 106473 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 3 | 13650 | |
| , | 12720 | |
| 1 | 11287 | |
| 8 | 10494 | |
| 2 | 10039 | |
| 7 | 9655 | |
| 5 | 9170 | |
| 6 | 9095 | |
| 4 | 8427 | |
| 0 | 6197 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 106473 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 3 | 13650 | |
| , | 12720 | |
| 1 | 11287 | |
| 8 | 10494 | |
| 2 | 10039 | |
| 7 | 9655 | |
| 5 | 9170 | |
| 6 | 9095 | |
| 4 | 8427 | |
| 0 | 6197 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 106473 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 3 | 13650 | |
| , | 12720 | |
| 1 | 11287 | |
| 8 | 10494 | |
| 2 | 10039 | |
| 7 | 9655 | |
| 5 | 9170 | |
| 6 | 9095 | |
| 4 | 8427 | |
| 0 | 6197 |
Representatividad Temporal
Real number (ℝ)
| Distinct | 107 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 148 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 66.134131 |
| Minimum | 0 |
|---|---|
| Maximum | 167 |
| Zeros | 124 |
| Zeros (%) | 0.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 224.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 38 |
| median | 81 |
| Q3 | 94 |
| 95-th percentile | 99 |
| Maximum | 167 |
| Range | 167 |
| Interquartile range (IQR) | 56 |
Descriptive statistics
| Standard deviation | 33.027271 |
|---|---|
| Coefficient of variation (CV) | 0.49939827 |
| Kurtosis | -0.98633987 |
| Mean | 66.134131 |
| Median Absolute Deviation (MAD) | 17 |
| Skewness | -0.71825173 |
| Sum | 1890378 |
| Variance | 1090.8006 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 99 | 1547 | 5.4% |
| 100 | 1368 | 4.8% |
| 98 | 1171 | 4.1% |
| 97 | 1073 | 3.7% |
| 96 | 955 | 3.3% |
| 95 | 864 | 3.0% |
| 92 | 822 | 2.9% |
| 93 | 778 | 2.7% |
| 8 | 735 | 2.6% |
| 94 | 724 | 2.5% |
| Other values (97) | 18547 |
| Value | Count | Frequency (%) |
| 0 | 124 | 0.4% |
| 1 | 301 | |
| 2 | 267 | 0.9% |
| 3 | 138 | 0.5% |
| 4 | 337 | |
| 5 | 338 | |
| 6 | 246 | 0.9% |
| 7 | 299 | |
| 8 | 735 | |
| 9 | 98 | 0.3% |
| Value | Count | Frequency (%) |
| 167 | 2 | < 0.1% |
| 115 | 2 | < 0.1% |
| 112 | 2 | < 0.1% |
| 103 | 6 | < 0.1% |
| 102 | 6 | < 0.1% |
| 101 | 6 | < 0.1% |
| 100 | 1368 | |
| 99 | 1547 | |
| 98 | 1171 | |
| 97 | 1073 |
Excedencias limite actual
Real number (ℝ)
High correlation Zeros
| Distinct | 608 |
|---|---|
| Distinct (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.825491 |
| Minimum | 0 |
|---|---|
| Maximum | 3292 |
| Zeros | 23462 |
| Zeros (%) | 81.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 224.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 102 |
| Maximum | 3292 |
| Range | 3292 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 146.75311 |
|---|---|
| Coefficient of variation (CV) | 5.4706587 |
| Kurtosis | 114.99405 |
| Mean | 26.825491 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 9.2496726 |
| Sum | 770750 |
| Variance | 21536.474 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 23462 | |
| 1 | 752 | 2.6% |
| 2 | 415 | 1.4% |
| 3 | 259 | 0.9% |
| 4 | 206 | 0.7% |
| 5 | 160 | 0.6% |
| 6 | 127 | 0.4% |
| 7 | 124 | 0.4% |
| 8 | 116 | 0.4% |
| 9 | 95 | 0.3% |
| Other values (598) | 3016 | 10.5% |
| Value | Count | Frequency (%) |
| 0 | 23462 | |
| 1 | 752 | 2.6% |
| 2 | 415 | 1.4% |
| 3 | 259 | 0.9% |
| 4 | 206 | 0.7% |
| 5 | 160 | 0.6% |
| 6 | 127 | 0.4% |
| 7 | 124 | 0.4% |
| 8 | 116 | 0.4% |
| 9 | 95 | 0.3% |
| Value | Count | Frequency (%) |
| 3292 | 2 | |
| 2918 | 2 | |
| 2857 | 2 | |
| 2696 | 2 | |
| 2670 | 2 | |
| 2571 | 2 | |
| 2545 | 2 | |
| 2518 | 2 | |
| 2014 | 2 | |
| 1977 | 2 |
Porcentaje excedencias limite actual
Real number (ℝ)
High correlation Zeros
| Distinct | 1059 |
|---|---|
| Distinct (%) | 3.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.94618231 |
| Minimum | 0 |
|---|---|
| Maximum | 80.77 |
| Zeros | 23464 |
| Zeros (%) | 81.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 224.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 5.5545 |
| Maximum | 80.77 |
| Range | 80.77 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 4.1465051 |
|---|---|
| Coefficient of variation (CV) | 4.3823533 |
| Kurtosis | 95.540521 |
| Mean | 0.94618231 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 8.4110732 |
| Sum | 27185.71 |
| Variance | 17.193505 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 23464 | |
| 0.28 | 70 | 0.2% |
| 0.01 | 57 | 0.2% |
| 0.05 | 54 | 0.2% |
| 0.04 | 53 | 0.2% |
| 0.29 | 53 | 0.2% |
| 0.03 | 45 | 0.2% |
| 0.3 | 40 | 0.1% |
| 0.31 | 39 | 0.1% |
| 0.02 | 38 | 0.1% |
| Other values (1049) | 4819 | 16.8% |
| Value | Count | Frequency (%) |
| 0 | 23464 | |
| 0.01 | 57 | 0.2% |
| 0.02 | 38 | 0.1% |
| 0.03 | 45 | 0.2% |
| 0.04 | 53 | 0.2% |
| 0.05 | 54 | 0.2% |
| 0.06 | 20 | 0.1% |
| 0.07 | 31 | 0.1% |
| 0.08 | 28 | 0.1% |
| 0.09 | 19 | 0.1% |
| Value | Count | Frequency (%) |
| 80.77 | 2 | |
| 71.76 | 2 | |
| 70.42 | 2 | |
| 70 | 2 | |
| 69.17 | 2 | |
| 66.67 | 2 | |
| 66.2 | 2 | |
| 62.07 | 2 | |
| 60 | 4 | |
| 58.33 | 2 |
Mediana
Text
| Distinct | 2652 |
|---|---|
| Distinct (%) | 9.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 3.488619 |
| Min length | 1 |
Unique
| Unique | 51 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | 244.2 |
|---|---|
| 2nd row | 257.9 |
| 3rd row | 2.8 |
| 4th row | 646.1 |
| 5th row | 645.9 |
| Value | Count | Frequency (%) |
| 0 | 1405 | 4.9% |
| 1 | 395 | 1.4% |
| 0.9 | 225 | 0.8% |
| 0.8 | 211 | 0.7% |
| 1.2 | 194 | 0.7% |
| 1.1 | 184 | 0.6% |
| 0.4 | 169 | 0.6% |
| 0.6 | 164 | 0.6% |
| 0.5 | 161 | 0.6% |
| 1.4 | 156 | 0.5% |
| Other values (2642) | 25468 |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 22253 | |
| 1 | 13506 | |
| 2 | 11662 | |
| 3 | 8042 | 8.0% |
| 6 | 7050 | 7.0% |
| 4 | 7026 | 7.0% |
| 5 | 6618 | 6.6% |
| 7 | 6559 | 6.5% |
| 8 | 6176 | 6.2% |
| 0 | 5792 | 5.8% |
| Other values (2) | 5551 | 5.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 100235 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| . | 22253 | |
| 1 | 13506 | |
| 2 | 11662 | |
| 3 | 8042 | 8.0% |
| 6 | 7050 | 7.0% |
| 4 | 7026 | 7.0% |
| 5 | 6618 | 6.6% |
| 7 | 6559 | 6.5% |
| 8 | 6176 | 6.2% |
| 0 | 5792 | 5.8% |
| Other values (2) | 5551 | 5.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 100235 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| . | 22253 | |
| 1 | 13506 | |
| 2 | 11662 | |
| 3 | 8042 | 8.0% |
| 6 | 7050 | 7.0% |
| 4 | 7026 | 7.0% |
| 5 | 6618 | 6.6% |
| 7 | 6559 | 6.5% |
| 8 | 6176 | 6.2% |
| 0 | 5792 | 5.8% |
| Other values (2) | 5551 | 5.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 100235 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| . | 22253 | |
| 1 | 13506 | |
| 2 | 11662 | |
| 3 | 8042 | 8.0% |
| 6 | 7050 | 7.0% |
| 4 | 7026 | 7.0% |
| 5 | 6618 | 6.6% |
| 7 | 6559 | 6.5% |
| 8 | 6176 | 6.2% |
| 0 | 5792 | 5.8% |
| Other values (2) | 5551 | 5.5% |
Percentil 98
Text
| Distinct | 3592 |
|---|---|
| Distinct (%) | 12.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 3.8776973 |
| Min length | 1 |
Unique
| Unique | 73 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | 350.8 |
|---|---|
| 2nd row | 304.2 |
| 3rd row | 12.8 |
| 4th row | 648.1 |
| 5th row | 647.2 |
| Value | Count | Frequency (%) |
| 1 | 256 | 0.9% |
| 1.3 | 116 | 0.4% |
| 2.2 | 108 | 0.4% |
| 1.7 | 108 | 0.4% |
| 1.6 | 106 | 0.4% |
| 1.2 | 104 | 0.4% |
| 1.4 | 104 | 0.4% |
| 1.9 | 103 | 0.4% |
| 2 | 102 | 0.4% |
| 1.5 | 102 | 0.4% |
| Other values (3582) | 27523 |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 23892 | |
| 1 | 11566 | |
| 2 | 10981 | |
| 3 | 10695 | |
| 5 | 8830 | 7.9% |
| 6 | 8463 | 7.6% |
| 4 | 8428 | 7.6% |
| 8 | 8074 | 7.2% |
| 7 | 7849 | 7.0% |
| 9 | 7295 | 6.5% |
| Other values (2) | 5341 | 4.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 111414 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| . | 23892 | |
| 1 | 11566 | |
| 2 | 10981 | |
| 3 | 10695 | |
| 5 | 8830 | 7.9% |
| 6 | 8463 | 7.6% |
| 4 | 8428 | 7.6% |
| 8 | 8074 | 7.2% |
| 7 | 7849 | 7.0% |
| 9 | 7295 | 6.5% |
| Other values (2) | 5341 | 4.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 111414 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| . | 23892 | |
| 1 | 11566 | |
| 2 | 10981 | |
| 3 | 10695 | |
| 5 | 8830 | 7.9% |
| 6 | 8463 | 7.6% |
| 4 | 8428 | 7.6% |
| 8 | 8074 | 7.2% |
| 7 | 7849 | 7.0% |
| 9 | 7295 | 6.5% |
| Other values (2) | 5341 | 4.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 111414 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| . | 23892 | |
| 1 | 11566 | |
| 2 | 10981 | |
| 3 | 10695 | |
| 5 | 8830 | 7.9% |
| 6 | 8463 | 7.6% |
| 4 | 8428 | 7.6% |
| 8 | 8074 | 7.2% |
| 7 | 7849 | 7.0% |
| 9 | 7295 | 6.5% |
| Other values (2) | 5341 | 4.8% |
Máximo
Text
| Distinct | 4214 |
|---|---|
| Distinct (%) | 14.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 MiB |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 4.0183071 |
| Min length | 1 |
Unique
| Unique | 105 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 359.5 |
|---|---|
| 2nd row | 336.8 |
| 3rd row | 23 |
| 4th row | 649.8 |
| 5th row | 647.9 |
| Value | Count | Frequency (%) |
| 360 | 572 | 2.0% |
| 100 | 209 | 0.7% |
| 359.9 | 164 | 0.6% |
| 1 | 162 | 0.6% |
| 359.8 | 94 | 0.3% |
| 359 | 84 | 0.3% |
| 1.8 | 76 | 0.3% |
| 2 | 74 | 0.3% |
| 3.1 | 69 | 0.2% |
| 337.5 | 62 | 0.2% |
| Other values (4204) | 27166 |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 23052 | |
| 1 | 13026 | |
| 3 | 11181 | |
| 2 | 10710 | |
| 5 | 8904 | 7.7% |
| 6 | 8776 | 7.6% |
| 9 | 8767 | 7.6% |
| 4 | 8346 | 7.2% |
| 8 | 8163 | 7.1% |
| 7 | 7743 | 6.7% |
| Other values (2) | 6786 | 5.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 115454 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| . | 23052 | |
| 1 | 13026 | |
| 3 | 11181 | |
| 2 | 10710 | |
| 5 | 8904 | 7.7% |
| 6 | 8776 | 7.6% |
| 9 | 8767 | 7.6% |
| 4 | 8346 | 7.2% |
| 8 | 8163 | 7.1% |
| 7 | 7743 | 6.7% |
| Other values (2) | 6786 | 5.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 115454 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| . | 23052 | |
| 1 | 13026 | |
| 3 | 11181 | |
| 2 | 10710 | |
| 5 | 8904 | 7.7% |
| 6 | 8776 | 7.6% |
| 9 | 8767 | 7.6% |
| 4 | 8346 | 7.2% |
| 8 | 8163 | 7.1% |
| 7 | 7743 | 6.7% |
| Other values (2) | 6786 | 5.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 115454 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| . | 23052 | |
| 1 | 13026 | |
| 3 | 11181 | |
| 2 | 10710 | |
| 5 | 8904 | 7.7% |
| 6 | 8776 | 7.6% |
| 9 | 8767 | 7.6% |
| 4 | 8346 | 7.2% |
| 8 | 8163 | 7.1% |
| 7 | 7743 | 6.7% |
| Other values (2) | 6786 | 5.9% |
| Distinct | 9695 |
|---|---|
| Distinct (%) | 33.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.2 MiB |
Length
| Max length | 2273 |
|---|---|
| Median length | 2227 |
| Mean length | 30.610052 |
| Min length | 5 |
Unique
| Unique | 472 ? |
|---|---|
| Unique (%) | 1.6% |
Sample
| 1st row | 29/11/2011 1:00 |
|---|---|
| 2nd row | 16/11/2011 0:00 |
| 3rd row | 20/12/2011 2:00 |
| 4th row | 12/09/2011 10:00 |
| 5th row | 20/10/2011 0:00 |
| Value | Count | Frequency (%) |
| 22152 | 19.5% | |
| 0:00 | 5830 | 5.1% |
| 12:00 | 3344 | 2.9% |
| 02/07/2016 | 2216 | 1.9% |
| 01/07/2016 | 2126 | 1.9% |
| 10:00:00 | 1614 | 1.4% |
| 12:00:00 | 1514 | 1.3% |
| 11:00:00 | 1465 | 1.3% |
| 05:00:00 | 1448 | 1.3% |
| 07:00:00 | 1446 | 1.3% |
| Other values (5891) | 70637 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 254903 | |
| 2 | 108102 | |
| 1 | 103097 | |
| / | 94274 | 10.7% |
| 92986 | 10.6% | |
| : | 62969 | 7.2% |
| 6 | 25002 | 2.8% |
| 3 | 23365 | 2.7% |
| - | 22254 | 2.5% |
| 4 | 21440 | 2.4% |
| Other values (12) | 71096 | 8.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 879488 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 254903 | |
| 2 | 108102 | |
| 1 | 103097 | |
| / | 94274 | 10.7% |
| 92986 | 10.6% | |
| : | 62969 | 7.2% |
| 6 | 25002 | 2.8% |
| 3 | 23365 | 2.7% |
| - | 22254 | 2.5% |
| 4 | 21440 | 2.4% |
| Other values (12) | 71096 | 8.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 879488 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 254903 | |
| 2 | 108102 | |
| 1 | 103097 | |
| / | 94274 | 10.7% |
| 92986 | 10.6% | |
| : | 62969 | 7.2% |
| 6 | 25002 | 2.8% |
| 3 | 23365 | 2.7% |
| - | 22254 | 2.5% |
| 4 | 21440 | 2.4% |
| Other values (12) | 71096 | 8.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 879488 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 254903 | |
| 2 | 108102 | |
| 1 | 103097 | |
| / | 94274 | 10.7% |
| 92986 | 10.6% | |
| : | 62969 | 7.2% |
| 6 | 25002 | 2.8% |
| 3 | 23365 | 2.7% |
| - | 22254 | 2.5% |
| 4 | 21440 | 2.4% |
| Other values (12) | 71096 | 8.1% |
Mínimo
Text
| Distinct | 1532 |
|---|---|
| Distinct (%) | 5.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 2.7678895 |
| Min length | 1 |
Unique
| Unique | 13 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 1.3 |
|---|---|
| 2nd row | 99.7 |
| 3rd row | 1.5 |
| 4th row | 641.6 |
| 5th row | 644 |
| Value | Count | Frequency (%) |
| 0 | 6024 | 21.0% |
| 1 | 1175 | 4.1% |
| 0.1 | 929 | 3.2% |
| 0.2 | 808 | 2.8% |
| 0.3 | 667 | 2.3% |
| 0.4 | 475 | 1.7% |
| 0.5 | 401 | 1.4% |
| 0.6 | 382 | 1.3% |
| 0.7 | 281 | 1.0% |
| 0.8 | 266 | 0.9% |
| Other values (1508) | 17324 |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 18987 | |
| 0 | 11881 | |
| 1 | 11454 | |
| 2 | 6863 | 8.6% |
| 3 | 5017 | 6.3% |
| 4 | 4927 | 6.2% |
| 5 | 4920 | 6.2% |
| 6 | 4652 | 5.8% |
| 7 | 3772 | 4.7% |
| 8 | 3704 | 4.7% |
| Other values (3) | 3350 | 4.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 79527 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| . | 18987 | |
| 0 | 11881 | |
| 1 | 11454 | |
| 2 | 6863 | 8.6% |
| 3 | 5017 | 6.3% |
| 4 | 4927 | 6.2% |
| 5 | 4920 | 6.2% |
| 6 | 4652 | 5.8% |
| 7 | 3772 | 4.7% |
| 8 | 3704 | 4.7% |
| Other values (3) | 3350 | 4.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 79527 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| . | 18987 | |
| 0 | 11881 | |
| 1 | 11454 | |
| 2 | 6863 | 8.6% |
| 3 | 5017 | 6.3% |
| 4 | 4927 | 6.2% |
| 5 | 4920 | 6.2% |
| 6 | 4652 | 5.8% |
| 7 | 3772 | 4.7% |
| 8 | 3704 | 4.7% |
| Other values (3) | 3350 | 4.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 79527 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| . | 18987 | |
| 0 | 11881 | |
| 1 | 11454 | |
| 2 | 6863 | 8.6% |
| 3 | 5017 | 6.3% |
| 4 | 4927 | 6.2% |
| 5 | 4920 | 6.2% |
| 6 | 4652 | 5.8% |
| 7 | 3772 | 4.7% |
| 8 | 3704 | 4.7% |
| Other values (3) | 3350 | 4.2% |
| Distinct | 10200 |
|---|---|
| Distinct (%) | 35.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
Length
| Max length | 2296 |
|---|---|
| Median length | 2227 |
| Mean length | 91.339099 |
| Min length | 5 |
Unique
| Unique | 571 ? |
|---|---|
| Unique (%) | 2.0% |
Sample
| 1st row | 29/11/2011 7:00 |
|---|---|
| 2nd row | 8/11/2011 0:00 |
| 3rd row | 07/11/2011 23:00:00 - 08/11/2011 05:00:00 - 13/11/2011 21:00:00 - 14/11/2011 20:00:00 - 18/11/2011 22:00:00 - 19/11/2011 03:00:00 - 21/11/2011 19:00:00 - 23/11/2011 19:00:00 - 23/11/2011 20:00:00 - 23/11/2011 21:00:00 - 24/11/2011 19:00:00 - 28/11/2011 20:00:00 - 30/11/2011 15:00:00 - 05/12/2011 03:00:00 - 05/12/2011 04:00:00 - 08/12/2011 03:00:00 - 13/12/2011 09:00:00 - 21/12/2011 05:00:00 - 23/12/2011 02:00:00 |
| 4th row | 27/10/2011 17:00 |
| 5th row | 27/10/2011 0:00 |
| Value | Count | Frequency (%) |
| 100630 | ||
| 12:00:00 | 15851 | 4.6% |
| 00:00:00 | 9363 | 2.7% |
| 04:00:00 | 7706 | 2.2% |
| 03:00:00 | 7147 | 2.1% |
| 05:00:00 | 6786 | 2.0% |
| 02:00:00 | 6216 | 1.8% |
| 06:00:00 | 6086 | 1.8% |
| 01:00:00 | 5440 | 1.6% |
| 07:00:00 | 5097 | 1.5% |
| Other values (6503) | 174621 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 797600 | |
| 361409 | ||
| 2 | 312496 | 11.9% |
| 1 | 262650 | 10.0% |
| / | 241998 | 9.2% |
| : | 216784 | 8.3% |
| - | 106540 | 4.1% |
| 3 | 49432 | 1.9% |
| 7 | 47191 | 1.8% |
| 6 | 44566 | 1.7% |
| Other values (12) | 183689 | 7.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2624355 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 797600 | |
| 361409 | ||
| 2 | 312496 | 11.9% |
| 1 | 262650 | 10.0% |
| / | 241998 | 9.2% |
| : | 216784 | 8.3% |
| - | 106540 | 4.1% |
| 3 | 49432 | 1.9% |
| 7 | 47191 | 1.8% |
| 6 | 44566 | 1.7% |
| Other values (12) | 183689 | 7.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2624355 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 797600 | |
| 361409 | ||
| 2 | 312496 | 11.9% |
| 1 | 262650 | 10.0% |
| / | 241998 | 9.2% |
| : | 216784 | 8.3% |
| - | 106540 | 4.1% |
| 3 | 49432 | 1.9% |
| 7 | 47191 | 1.8% |
| 6 | 44566 | 1.7% |
| Other values (12) | 183689 | 7.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2624355 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 797600 | |
| 361409 | ||
| 2 | 312496 | 11.9% |
| 1 | 262650 | 10.0% |
| / | 241998 | 9.2% |
| : | 216784 | 8.3% |
| - | 106540 | 4.1% |
| 3 | 49432 | 1.9% |
| 7 | 47191 | 1.8% |
| 6 | 44566 | 1.7% |
| Other values (12) | 183689 | 7.0% |
Días de excedencias
Real number (ℝ)
High correlation Zeros
| Distinct | 256 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.1496937 |
| Minimum | 0 |
|---|---|
| Maximum | 327 |
| Zeros | 23464 |
| Zeros (%) | 81.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 224.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 44 |
| Maximum | 327 |
| Range | 327 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 29.204741 |
|---|---|
| Coefficient of variation (CV) | 4.0847541 |
| Kurtosis | 37.58684 |
| Mean | 7.1496937 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.7316839 |
| Sum | 205425 |
| Variance | 852.91689 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 23464 | |
| 1 | 856 | 3.0% |
| 2 | 450 | 1.6% |
| 3 | 262 | 0.9% |
| 4 | 247 | 0.9% |
| 5 | 176 | 0.6% |
| 6 | 164 | 0.6% |
| 7 | 145 | 0.5% |
| 8 | 120 | 0.4% |
| 9 | 110 | 0.4% |
| Other values (246) | 2738 | 9.5% |
| Value | Count | Frequency (%) |
| 0 | 23464 | |
| 1 | 856 | 3.0% |
| 2 | 450 | 1.6% |
| 3 | 262 | 0.9% |
| 4 | 247 | 0.9% |
| 5 | 176 | 0.6% |
| 6 | 164 | 0.6% |
| 7 | 145 | 0.5% |
| 8 | 120 | 0.4% |
| 9 | 110 | 0.4% |
| Value | Count | Frequency (%) |
| 327 | 2 | < 0.1% |
| 323 | 2 | < 0.1% |
| 310 | 2 | < 0.1% |
| 306 | 2 | < 0.1% |
| 299 | 1 | < 0.1% |
| 294 | 2 | < 0.1% |
| 291 | 5 | |
| 290 | 4 | |
| 288 | 2 | < 0.1% |
| 287 | 2 | < 0.1% |
Código del Departamento
Real number (ℝ)
High correlation
| Distinct | 24 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.078275 |
| Minimum | 5 |
|---|---|
| Maximum | 85 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 224.6 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 5 |
| median | 11 |
| Q3 | 44 |
| 95-th percentile | 76 |
| Maximum | 85 |
| Range | 80 |
| Interquartile range (IQR) | 39 |
Descriptive statistics
| Standard deviation | 25.279328 |
|---|---|
| Coefficient of variation (CV) | 1.008017 |
| Kurtosis | -0.4021864 |
| Mean | 25.078275 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 1.1014324 |
| Sum | 720549 |
| Variance | 639.04441 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=24)
| Value | Count | Frequency (%) |
| 5 | 8633 | |
| 11 | 6141 | |
| 76 | 2936 | 10.2% |
| 68 | 1910 | 6.6% |
| 25 | 1700 | 5.9% |
| 15 | 1653 | 5.8% |
| 20 | 1072 | 3.7% |
| 47 | 1016 | 3.5% |
| 8 | 839 | 2.9% |
| 44 | 780 | 2.7% |
| Other values (14) | 2052 | 7.1% |
| Value | Count | Frequency (%) |
| 5 | 8633 | |
| 8 | 839 | 2.9% |
| 11 | 6141 | |
| 13 | 270 | 0.9% |
| 15 | 1653 | 5.8% |
| 17 | 208 | 0.7% |
| 19 | 295 | 1.0% |
| 20 | 1072 | 3.7% |
| 23 | 188 | 0.7% |
| 25 | 1700 | 5.9% |
| Value | Count | Frequency (%) |
| 85 | 22 | 0.1% |
| 81 | 50 | 0.2% |
| 76 | 2936 | |
| 73 | 105 | 0.4% |
| 68 | 1910 | |
| 66 | 172 | 0.6% |
| 63 | 38 | 0.1% |
| 54 | 123 | 0.4% |
| 52 | 22 | 0.1% |
| 50 | 495 | 1.7% |
Nombre del Departamento
Categorical
High correlation
| Distinct | 48 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| ANTIOQUIA | |
|---|---|
| BOGOTÁ, D.C. | |
| VALLE DEL CAUCA | |
| SANTANDER | |
| BOGOTA, D.C. | |
| Other values (43) |
Length
| Max length | 18 |
|---|---|
| Median length | 15 |
| Mean length | 9.9640471 |
| Min length | 4 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | ANTIOQUIA |
|---|---|
| 2nd row | ANTIOQUIA |
| 3rd row | ANTIOQUIA |
| 4th row | ANTIOQUIA |
| 5th row | ANTIOQUIA |
Common Values
| Value | Count | Frequency (%) |
| ANTIOQUIA | 8486 | |
| BOGOTÁ, D.C. | 4285 | |
| VALLE DEL CAUCA | 2868 | 10.0% |
| SANTANDER | 1880 | 6.5% |
| BOGOTA, D.C. | 1680 | 5.8% |
| CUNDINAMARCA | 1514 | 5.3% |
| CESAR | 1048 | 3.6% |
| BOYACÁ | 1030 | 3.6% |
| MAGDALENA | 986 | 3.4% |
| LA GUAJIRA | 764 | 2.7% |
| Other values (38) | 4191 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| antioquia | 8633 | |
| d.c | 6141 | |
| bogotá | 4461 | |
| cauca | 3231 | 7.7% |
| valle | 2936 | 7.0% |
| del | 2936 | 7.0% |
| santander | 2033 | 4.9% |
| cundinamarca | 1700 | 4.1% |
| bogota | 1680 | 4.0% |
| boyacá | 1089 | 2.6% |
| Other values (23) | 6931 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 48132 | |
| O | 23594 | 8.2% |
| I | 20456 | 7.1% |
| C | 19724 | 6.9% |
| T | 18808 | 6.6% |
| N | 17527 | 6.1% |
| D | 14195 | 5.0% |
| U | 14060 | 4.9% |
| 13039 | 4.6% | |
| . | 12282 | 4.3% |
| Other values (39) | 84470 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 286287 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 48132 | |
| O | 23594 | 8.2% |
| I | 20456 | 7.1% |
| C | 19724 | 6.9% |
| T | 18808 | 6.6% |
| N | 17527 | 6.1% |
| D | 14195 | 5.0% |
| U | 14060 | 4.9% |
| 13039 | 4.6% | |
| . | 12282 | 4.3% |
| Other values (39) | 84470 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 286287 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 48132 | |
| O | 23594 | 8.2% |
| I | 20456 | 7.1% |
| C | 19724 | 6.9% |
| T | 18808 | 6.6% |
| N | 17527 | 6.1% |
| D | 14195 | 5.0% |
| U | 14060 | 4.9% |
| 13039 | 4.6% | |
| . | 12282 | 4.3% |
| Other values (39) | 84470 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 286287 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 48132 | |
| O | 23594 | 8.2% |
| I | 20456 | 7.1% |
| C | 19724 | 6.9% |
| T | 18808 | 6.6% |
| N | 17527 | 6.1% |
| D | 14195 | 5.0% |
| U | 14060 | 4.9% |
| 13039 | 4.6% | |
| . | 12282 | 4.3% |
| Other values (39) | 84470 |
Código del Municipio
Real number (ℝ)
High correlation
| Distinct | 186 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 4 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25276.643 |
| Minimum | 5001 |
|---|---|
| Maximum | 85001 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 224.6 KiB |
Quantile statistics
| Minimum | 5001 |
|---|---|
| 5-th percentile | 5001 |
| Q1 | 5440 |
| median | 11001 |
| Q3 | 44279 |
| 95-th percentile | 76001 |
| Maximum | 85001 |
| Range | 80000 |
| Interquartile range (IQR) | 38839 |
Descriptive statistics
| Standard deviation | 25267.373 |
|---|---|
| Coefficient of variation (CV) | 0.99963327 |
| Kurtosis | -0.40083048 |
| Mean | 25276.643 |
| Median Absolute Deviation (MAD) | 5922 |
| Skewness | 1.1001653 |
| Sum | 7.2614739 × 108 |
| Variance | 6.3844014 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 11001 | 6145 | |
| 5001 | 2773 | 9.7% |
| 76001 | 2064 | 7.2% |
| 68001 | 1326 | 4.6% |
| 5360 | 945 | 3.3% |
| 15759 | 918 | 3.2% |
| 5308 | 844 | 2.9% |
| 47001 | 706 | 2.5% |
| 8001 | 609 | 2.1% |
| 15491 | 515 | 1.8% |
| Other values (176) | 11883 |
| Value | Count | Frequency (%) |
| 5001 | 2773 | |
| 5030 | 124 | 0.4% |
| 5031 | 6 | < 0.1% |
| 5034 | 18 | 0.1% |
| 5036 | 6 | < 0.1% |
| 5038 | 10 | < 0.1% |
| 5040 | 2 | < 0.1% |
| 5042 | 56 | 0.2% |
| 5044 | 10 | < 0.1% |
| 5059 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 85001 | 42 | 0.1% |
| 81001 | 30 | 0.1% |
| 76895 | 4 | < 0.1% |
| 76892 | 338 | |
| 76834 | 53 | 0.2% |
| 76520 | 283 | |
| 76364 | 80 | 0.3% |
| 76147 | 8 | < 0.1% |
| 76130 | 86 | 0.3% |
| 76111 | 14 | < 0.1% |
Nombre del Municipio
Text
| Distinct | 301 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
Length
| Max length | 25 |
|---|---|
| Median length | 21 |
| Mean length | 9.0287484 |
| Min length | 4 |
Unique
| Unique | 6 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | GIRARDOTA |
|---|---|
| 2nd row | GIRARDOTA |
| 3rd row | GIRARDOTA |
| 4th row | GIRARDOTA |
| 5th row | GIRARDOTA |
| Value | Count | Frequency (%) |
| d.c | 6145 | 15.8% |
| bogotá | 4285 | 11.0% |
| cali | 2064 | 5.3% |
| medellín | 1860 | 4.8% |
| bogota | 1860 | 4.8% |
| bucaramanga | 1326 | 3.4% |
| sogamoso | 918 | 2.4% |
| medellin | 913 | 2.3% |
| girardota | 844 | 2.2% |
| santa | 807 | 2.1% |
| Other values (232) | 17965 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 35645 | 13.7% |
| O | 22958 | 8.8% |
| C | 15391 | 5.9% |
| L | 14678 | 5.7% |
| I | 13319 | 5.1% |
| D | 13154 | 5.1% |
| B | 12398 | 4.8% |
| . | 12290 | 4.7% |
| G | 12255 | 4.7% |
| N | 12046 | 4.6% |
| Other values (45) | 95280 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 259414 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 35645 | 13.7% |
| O | 22958 | 8.8% |
| C | 15391 | 5.9% |
| L | 14678 | 5.7% |
| I | 13319 | 5.1% |
| D | 13154 | 5.1% |
| B | 12398 | 4.8% |
| . | 12290 | 4.7% |
| G | 12255 | 4.7% |
| N | 12046 | 4.6% |
| Other values (45) | 95280 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 259414 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 35645 | 13.7% |
| O | 22958 | 8.8% |
| C | 15391 | 5.9% |
| L | 14678 | 5.7% |
| I | 13319 | 5.1% |
| D | 13154 | 5.1% |
| B | 12398 | 4.8% |
| . | 12290 | 4.7% |
| G | 12255 | 4.7% |
| N | 12046 | 4.6% |
| Other values (45) | 95280 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 259414 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 35645 | 13.7% |
| O | 22958 | 8.8% |
| C | 15391 | 5.9% |
| L | 14678 | 5.7% |
| I | 13319 | 5.1% |
| D | 13154 | 5.1% |
| B | 12398 | 4.8% |
| . | 12290 | 4.7% |
| G | 12255 | 4.7% |
| N | 12046 | 4.6% |
| Other values (45) | 95280 |
Tipo de Estación
Categorical
High correlation Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Memory size | 1.5 MiB |
| Fija | |
|---|---|
| Indicativa |
Length
| Max length | 10 |
|---|---|
| Median length | 4 |
| Mean length | 4.6175426 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Fija |
|---|---|
| 2nd row | Fija |
| 3rd row | Fija |
| 4th row | Fija |
| 5th row | Fija |
Common Values
| Value | Count | Frequency (%) |
| Fija | 25773 | |
| Indicativa | 2957 | 10.3% |
| (Missing) | 2 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| fija | 25773 | |
| indicativa | 2957 | 10.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 31687 | |
| a | 31687 | |
| F | 25773 | |
| j | 25773 | |
| I | 2957 | 2.2% |
| n | 2957 | 2.2% |
| d | 2957 | 2.2% |
| c | 2957 | 2.2% |
| t | 2957 | 2.2% |
| v | 2957 | 2.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 132662 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 31687 | |
| a | 31687 | |
| F | 25773 | |
| j | 25773 | |
| I | 2957 | 2.2% |
| n | 2957 | 2.2% |
| d | 2957 | 2.2% |
| c | 2957 | 2.2% |
| t | 2957 | 2.2% |
| v | 2957 | 2.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 132662 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 31687 | |
| a | 31687 | |
| F | 25773 | |
| j | 25773 | |
| I | 2957 | 2.2% |
| n | 2957 | 2.2% |
| d | 2957 | 2.2% |
| c | 2957 | 2.2% |
| t | 2957 | 2.2% |
| v | 2957 | 2.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 132662 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 31687 | |
| a | 31687 | |
| F | 25773 | |
| j | 25773 | |
| I | 2957 | 2.2% |
| n | 2957 | 2.2% |
| d | 2957 | 2.2% |
| c | 2957 | 2.2% |
| t | 2957 | 2.2% |
| v | 2957 | 2.2% |
Ubicacion
Text
| Distinct | 606 |
|---|---|
| Distinct (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
Length
| Max length | 35 |
|---|---|
| Median length | 27 |
| Mean length | 26.917026 |
| Min length | 20 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | POINT (-75.443986 6.378517) |
|---|---|
| 2nd row | POINT (-75.443986 6.378517) |
| 3rd row | POINT (-75.443986 6.378517) |
| 4th row | POINT (-75.443986 6.378517) |
| 5th row | POINT (-75.443986 6.378517) |
| Value | Count | Frequency (%) |
| point | 28732 | |
| 74.083967 | 638 | 0.7% |
| 4.62505 | 528 | 0.6% |
| 74.161333 | 528 | 0.6% |
| 4.658467 | 526 | 0.6% |
| 74.082483 | 481 | 0.6% |
| 4.6907 | 481 | 0.6% |
| 74.148583 | 474 | 0.5% |
| 4.595617 | 474 | 0.5% |
| 74.117483 | 458 | 0.5% |
| Other values (1187) | 52876 |
Most occurring characters
| Value | Count | Frequency (%) |
| 7 | 64834 | 8.4% |
| 57464 | 7.4% | |
| . | 57464 | 7.4% |
| 6 | 51615 | 6.7% |
| 4 | 48398 | 6.3% |
| 5 | 46683 | 6.0% |
| 1 | 46274 | 6.0% |
| 3 | 45251 | 5.9% |
| 8 | 34826 | 4.5% |
| 2 | 32614 | 4.2% |
| Other values (10) | 287957 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 773380 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 7 | 64834 | 8.4% |
| 57464 | 7.4% | |
| . | 57464 | 7.4% |
| 6 | 51615 | 6.7% |
| 4 | 48398 | 6.3% |
| 5 | 46683 | 6.0% |
| 1 | 46274 | 6.0% |
| 3 | 45251 | 5.9% |
| 8 | 34826 | 4.5% |
| 2 | 32614 | 4.2% |
| Other values (10) | 287957 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 773380 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 7 | 64834 | 8.4% |
| 57464 | 7.4% | |
| . | 57464 | 7.4% |
| 6 | 51615 | 6.7% |
| 4 | 48398 | 6.3% |
| 5 | 46683 | 6.0% |
| 1 | 46274 | 6.0% |
| 3 | 45251 | 5.9% |
| 8 | 34826 | 4.5% |
| 2 | 32614 | 4.2% |
| Other values (10) | 287957 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 773380 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 7 | 64834 | 8.4% |
| 57464 | 7.4% | |
| . | 57464 | 7.4% |
| 6 | 51615 | 6.7% |
| 4 | 48398 | 6.3% |
| 5 | 46683 | 6.0% |
| 1 | 46274 | 6.0% |
| 3 | 45251 | 5.9% |
| 8 | 34826 | 4.5% |
| 2 | 32614 | 4.2% |
| Other values (10) | 287957 |
Interactions
Correlations
| Autoridad Ambiental | Año | Código del Departamento | Código del Municipio | Días de excedencias | Excedencias limite actual | Latitud | Longitud | Nombre del Departamento | Porcentaje excedencias limite actual | Representatividad Temporal | Tiempo de exposición (horas) | Tipo de Estación | Unidades | Variable | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Autoridad Ambiental | 1.000 | 0.178 | 0.990 | 0.990 | 0.059 | 0.034 | 0.879 | 0.812 | 0.874 | 0.088 | 0.255 | 0.194 | 0.784 | 0.171 | 0.174 |
| Año | 0.178 | 1.000 | 0.113 | 0.113 | 0.062 | 0.051 | 0.094 | 0.092 | 0.357 | 0.051 | 0.076 | 0.076 | 0.129 | 0.074 | 0.129 |
| Código del Departamento | 0.990 | 0.113 | 1.000 | 0.986 | 0.039 | 0.039 | -0.256 | 0.237 | 0.999 | 0.045 | -0.029 | 0.097 | 0.241 | 0.116 | 0.170 |
| Código del Municipio | 0.990 | 0.113 | 0.986 | 1.000 | 0.031 | 0.031 | -0.256 | 0.240 | 0.998 | 0.038 | -0.055 | 0.096 | 0.241 | 0.116 | 0.170 |
| Días de excedencias | 0.059 | 0.062 | 0.039 | 0.031 | 1.000 | 0.999 | -0.030 | 0.034 | 0.060 | 0.995 | 0.056 | 0.129 | 0.067 | 0.085 | 0.116 |
| Excedencias limite actual | 0.034 | 0.051 | 0.039 | 0.031 | 0.999 | 1.000 | -0.030 | 0.034 | 0.021 | 0.994 | 0.055 | 0.099 | 0.049 | 0.053 | 0.077 |
| Latitud | 0.879 | 0.094 | -0.256 | -0.256 | -0.030 | -0.030 | 1.000 | 0.276 | 0.874 | -0.019 | -0.101 | 0.131 | 0.317 | 0.102 | 0.156 |
| Longitud | 0.812 | 0.092 | 0.237 | 0.240 | 0.034 | 0.034 | 0.276 | 1.000 | 0.819 | 0.038 | 0.107 | 0.100 | 0.302 | 0.088 | 0.139 |
| Nombre del Departamento | 0.874 | 0.357 | 0.999 | 0.998 | 0.060 | 0.021 | 0.874 | 0.819 | 1.000 | 0.094 | 0.198 | 0.184 | 0.506 | 0.160 | 0.164 |
| Porcentaje excedencias limite actual | 0.088 | 0.051 | 0.045 | 0.038 | 0.995 | 0.994 | -0.019 | 0.038 | 0.094 | 1.000 | 0.045 | 0.016 | 0.036 | 0.063 | 0.089 |
| Representatividad Temporal | 0.255 | 0.076 | -0.029 | -0.055 | 0.056 | 0.055 | -0.101 | 0.107 | 0.198 | 0.045 | 1.000 | 0.067 | 0.484 | 0.069 | 0.095 |
| Tiempo de exposición (horas) | 0.194 | 0.076 | 0.097 | 0.096 | 0.129 | 0.099 | 0.131 | 0.100 | 0.184 | 0.016 | 0.067 | 1.000 | 0.135 | 0.145 | 0.516 |
| Tipo de Estación | 0.784 | 0.129 | 0.241 | 0.241 | 0.067 | 0.049 | 0.317 | 0.302 | 0.506 | 0.036 | 0.484 | 0.135 | 1.000 | 0.148 | 0.204 |
| Unidades | 0.171 | 0.074 | 0.116 | 0.116 | 0.085 | 0.053 | 0.102 | 0.088 | 0.160 | 0.063 | 0.069 | 0.145 | 0.148 | 1.000 | 1.000 |
| Variable | 0.174 | 0.129 | 0.170 | 0.170 | 0.116 | 0.077 | 0.156 | 0.139 | 0.164 | 0.089 | 0.095 | 0.516 | 0.204 | 1.000 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| ID Estacion | Autoridad Ambiental | Estación | Latitud | Longitud | Variable | Unidades | Tiempo de exposición (horas) | Año | Promedio | Suma | No. de datos | Representatividad Temporal | Excedencias limite actual | Porcentaje excedencias limite actual | Mediana | Percentil 98 | Máximo | Fechas/horas del máximo | Mínimo | Fechas/horas del mínimo | Días de excedencias | Código del Departamento | Nombre del Departamento | Código del Municipio | Nombre del Municipio | Tipo de Estación | Ubicacion | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 9,020 | AMVA | I.E. COL. COLOMBIA | 6.378517 | -75.443986 | DViento | deg | 1 | 2,011 | 256.8 | 321,637.5091 | 1,411 | 16.0 | 0 | 0.0 | 244.2 | 350.8 | 359.5 | 29/11/2011 1:00 | 1.3 | 29/11/2011 7:00 | 0 | 5 | ANTIOQUIA | 5308.0 | GIRARDOTA | Fija | POINT (-75.443986 6.378517) |
| 1 | 9,020 | AMVA | I.E. COL. COLOMBIA | 6.378517 | -75.443986 | DViento | deg | 24 | 2,011 | 257.4 | 14,984.01 | 59 | 16.0 | 0 | 0.0 | 257.9 | 304.2 | 336.8 | 16/11/2011 0:00 | 99.7 | 8/11/2011 0:00 | 0 | 5 | ANTIOQUIA | 5308.0 | GIRARDOTA | Fija | POINT (-75.443986 6.378517) |
| 2 | 9,020 | AMVA | I.E. COL. COLOMBIA | 6.378517 | -75.443986 | PLiquida | mm | 1 | 2,011 | 4 | 293.5 | 74 | 1.0 | 0 | 0.0 | 2.8 | 12.8 | 23 | 20/12/2011 2:00 | 1.5 | 07/11/2011 23:00:00 - 08/11/2011 05:00:00 - 13/11/2011 21:00:00 - 14/11/2011 20:00:00 - 18/11/2011 22:00:00 - 19/11/2011 03:00:00 - 21/11/2011 19:00:00 - 23/11/2011 19:00:00 - 23/11/2011 20:00:00 - 23/11/2011 21:00:00 - 24/11/2011 19:00:00 - 28/11/2011 20:00:00 - 30/11/2011 15:00:00 - 05/12/2011 03:00:00 - 05/12/2011 04:00:00 - 08/12/2011 03:00:00 - 13/12/2011 09:00:00 - 21/12/2011 05:00:00 - 23/12/2011 02:00:00 | 0 | 5 | ANTIOQUIA | 5308.0 | GIRARDOTA | Fija | POINT (-75.443986 6.378517) |
| 3 | 9,020 | AMVA | I.E. COL. COLOMBIA | 6.378517 | -75.443986 | P | mmHg | 1 | 2,011 | 645.9 | 2,917,013.928 | 4,516 | 52.0 | 0 | 0.0 | 646.1 | 648.1 | 649.8 | 12/09/2011 10:00 | 641.6 | 27/10/2011 17:00 | 0 | 5 | ANTIOQUIA | 5308.0 | GIRARDOTA | Fija | POINT (-75.443986 6.378517) |
| 4 | 9,020 | AMVA | I.E. COL. COLOMBIA | 6.378517 | -75.443986 | P | mmHg | 24 | 2,011 | 645.9 | 121,434.69 | 188 | 52.0 | 0 | 0.0 | 645.9 | 647.2 | 647.9 | 20/10/2011 0:00 | 644 | 27/10/2011 0:00 | 0 | 5 | ANTIOQUIA | 5308.0 | GIRARDOTA | Fija | POINT (-75.443986 6.378517) |
| 5 | 9,020 | AMVA | I.E. COL. COLOMBIA | 6.378517 | -75.443986 | PST | ugm3 | 24 | 2,011 | 72 | 6,353.05 | 84 | 69.0 | 0 | 0.0 | 73.4 | 124.8 | 155.7 | 2/12/2011 | 21.1 | 23/06/2011 | 0 | 5 | ANTIOQUIA | 5308.0 | GIRARDOTA | Fija | POINT (-75.443986 6.378517) |
| 6 | 9,020 | AMVA | I.E. COL. COLOMBIA | 6.378517 | -75.443986 | RGlobal | Wm2 | 1 | 2,011 | 158.9 | 224,195.8715 | 1,411 | 16.0 | 0 | 0.0 | 6.5 | 777.3 | 946.6 | 19/11/2011 13:00 | 4 | 03/11/2011 01:00:00 - 03/11/2011 02:00:00 - 03/11/2011 03:00:00 - 03/11/2011 04:00:00 - 03/11/2011 05:00:00 - 03/11/2011 06:00:00 - 03/11/2011 20:00:00 - 03/11/2011 21:00:00 - 03/11/2011 22:00:00 - 03/11/2011 23:00:00 - 04/11/2011 00:00:00 - 04/11/2011 01:00:00 - 04/11/2011 02:00:00 - 04/11/2011 03:00:00 - 04/11/2011 04:00:00 - 04/11/2011 05:00:00 - 04/11/2011 06:00:00 - 04/11/2011 20:00:00 - 04/11/2011 21:00:00 - 04/11/2011 22:00:00 - 04/11/2011 23:00:00 - 05/11/2011 00:00:00 - 05/11/2011 01:00:00 - 05/11/2011 02:00:00 - 05/11/2011 03:00:00 - 05/11/2011 04:00:00 - 05/11/2011 05:00:00 - 05/11/2011 06:00:00 - 05/11/2011 20:00:00 - 05/11/2011 21:00:00 - 05/11/2011 22:00:00 - 05/11/2011 23:00:00 - 06/11/2011 00:00:00 - 06/11/2011 01:00:00 - 06/11/2011 02:00:00 - 06/11/2011 03:00:00 - 06/11/2011 04:00:00 - 06/11/2011 05:00:00 - 14/11/2011 20:00:00 - 14/11/2011 21:00:00 - 14/11/2011 22:00:00 - 14/11/2011 23:00:00 - 15/11/2011 00:00:00 - 15/11/2011 01:00:00 - 15/11/2011 02:00:00 - 15/11/2011 03:00:00 - 15/11/2011 04:00:00 - 15/11/2011 05:00:00 - 15/11/2011 06:00:00 - 15/12/2011 20:00:00 - 15/12/2011 21:00:00 - 15/12/2011 22:00:00 - 15/12/2011 23:00:00 - 16/12/2011 00:00:00 - 16/12/2011 01:00:00 - 16/12/2011 02:00:00 - 16/12/2011 03:00:00 - 16/12/2011 04:00:00 - 16/12/2011 05:00:00 - 16/12/2011 06:00:00 - 16/12/2011 07:00:00 - 16/12/2011 21:00:00 - 16/12/2011 22:00:00 - 16/12/2011 23:00:00 - 17/12/2011 00:00:00 - 17/12/2011 01:00:00 - 31/12/2011 00:00:00 - 31/12/2011 04:00:00 - 31/12/2011 05:00:00 | 0 | 5 | ANTIOQUIA | 5308.0 | GIRARDOTA | Fija | POINT (-75.443986 6.378517) |
| 7 | 9,020 | AMVA | I.E. COL. COLOMBIA | 6.378517 | -75.443986 | RGlobal | Wm2 | 24 | 2,011 | 158.9 | 9,375.37 | 59 | 16.0 | 0 | 0.0 | 157 | 227.4 | 233.4 | 21/11/2011 0:00 | 105.8 | 27/12/2011 0:00 | 0 | 5 | ANTIOQUIA | 5308.0 | GIRARDOTA | Fija | POINT (-75.443986 6.378517) |
| 8 | 9,020 | AMVA | I.E. COL. COLOMBIA | 6.378517 | -75.443986 | TAire2 | Celsius | 1 | 2,011 | 21.2 | 14,682.27347 | 694 | 8.0 | 0 | 0.0 | 20.2 | 27.1 | 29.3 | 22/12/2011 16:00 | 16.8 | 12/12/2011 8:00 | 0 | 5 | ANTIOQUIA | 5308.0 | GIRARDOTA | Fija | POINT (-75.443986 6.378517) |
| 9 | 9,020 | AMVA | I.E. COL. COLOMBIA | 6.378517 | -75.443986 | TAire2 | Celsius | 24 | 2,011 | 21.2 | 613.55 | 29 | 8.0 | 0 | 0.0 | 21.2 | 22.6 | 23 | 22/12/2011 0:00 | 19.4 | 8/12/2011 0:00 | 0 | 5 | ANTIOQUIA | 5308.0 | GIRARDOTA | Fija | POINT (-75.443986 6.378517) |
| ID Estacion | Autoridad Ambiental | Estación | Latitud | Longitud | Variable | Unidades | Tiempo de exposición (horas) | Año | Promedio | Suma | No. de datos | Representatividad Temporal | Excedencias limite actual | Porcentaje excedencias limite actual | Mediana | Percentil 98 | Máximo | Fechas/horas del máximo | Mínimo | Fechas/horas del mínimo | Días de excedencias | Código del Departamento | Nombre del Departamento | Código del Municipio | Nombre del Municipio | Tipo de Estación | Ubicacion | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28722 | 31,876 | SDA | MÓVIL FONTIBÓN | 4.667694 | -74.148861 | CO | ugm3 | 1 | 2,023 | 804.2 | 6,297,503.54 | 7,831 | 89.0 | 0 | 0.00 | 686.9 | 2,093.9 | 4,421.4 | 24/02/2023 7:00 | 0 | 2023-01-31 14:00:00 - 2023-01-31 15:00:00 - 2023-01-31 16:00:00 - 2023-07-20 04:00:00 - 2023-11-27 00:00:00 | 0 | 11 | Bogotá, D.C. | 11001.0 | Bogota, D.C. | Fija | POINT (-74.148861 4.667694) |
| 28723 | 31,876 | SDA | MÓVIL FONTIBÓN | 4.667694 | -74.148861 | CO | ugm3 | 8 | 2,023 | 802.6 | 6,232,977.5 | 7,766 | 89.0 | 0 | 0.00 | 771 | 1,452.1 | 2,159.7 | 24/02/2023 10:00 | 156.4 | 31/01/2023 19:00 | 0 | 11 | Bogotá, D.C. | 11001.0 | Bogota, D.C. | Fija | POINT (-74.148861 4.667694) |
| 28724 | 31,876 | SDA | MÓVIL FONTIBÓN | 4.667694 | -74.148861 | NO2 | ugm3 | 1 | 2,023 | 42.7 | 333,719.27 | 7,823 | 89.0 | 0 | 0.00 | 42.1 | 77.7 | 115.5 | 5/04/2023 20:00 | 6.6 | 26/11/2023 12:00 | 0 | 11 | Bogotá, D.C. | 11001.0 | Bogota, D.C. | Fija | POINT (-74.148861 4.667694) |
| 28725 | 31,876 | SDA | MÓVIL FONTIBÓN | 4.667694 | -74.148861 | O3 | ugm3 | 8 | 2,023 | 20.2 | 142,354.8 | 7,039 | 80.0 | 0 | 0.00 | 16.3 | 66.9 | 96.6 | 27/01/2023 18:00 | 0 | 2023-05-27 06:00:00 - 2023-07-28 04:00:00 - 2023-07-28 05:00:00 - 2023-07-28 06:00:00 | 0 | 11 | Bogotá, D.C. | 11001.0 | Bogota, D.C. | Fija | POINT (-74.148861 4.667694) |
| 28726 | 31,876 | SDA | MÓVIL FONTIBÓN | 4.667694 | -74.148861 | PM10 | ugm3 | 1 | 2,023 | 53.6 | 416,156.8 | 7,766 | 89.0 | 1569 | 20.20 | 48.8 | 129.9 | 288 | 31/08/2023 14:00 | 3.1 | 17/04/2023 5:00 | 245 | 11 | Bogotá, D.C. | 11001.0 | Bogota, D.C. | Fija | POINT (-74.148861 4.667694) |
| 28727 | 31,876 | SDA | MÓVIL FONTIBÓN | 4.667694 | -74.148861 | PM10 | ugm3 | 24 | 2,023 | 53.5 | 17,484.66 | 327 | 90.0 | 45 | 13.76 | 53.1 | 90.9 | 101.5 | 31/08/2023 0:00 | 16.4 | 8/01/2023 0:00 | 45 | 11 | Bogotá, D.C. | 11001.0 | Bogota, D.C. | Fija | POINT (-74.148861 4.667694) |
| 28728 | 31,876 | SDA | MÓVIL FONTIBÓN | 4.667694 | -74.148861 | PM2.5 | ugm3 | 1 | 2,023 | 21.5 | 164,994.3 | 7,660 | 87.0 | 978 | 12.77 | 18.9 | 57.4 | 106.8 | 28/09/2023 21:00 | 0.4 | 2023-10-29 12:00:00 - 2023-11-04 20:00:00 | 215 | 11 | Bogotá, D.C. | 11001.0 | Bogota, D.C. | Fija | POINT (-74.148861 4.667694) |
| 28729 | 31,876 | SDA | MÓVIL FONTIBÓN | 4.667694 | -74.148861 | PM2.5 | ugm3 | 24 | 2,023 | 21.6 | 6,918.81 | 321 | 88.0 | 19 | 5.92 | 20.9 | 41.2 | 50.1 | 30/11/2023 0:00 | 3.8 | 29/10/2023 0:00 | 19 | 11 | Bogotá, D.C. | 11001.0 | Bogota, D.C. | Fija | POINT (-74.148861 4.667694) |
| 28730 | 31,876 | SDA | MÓVIL FONTIBÓN | 4.667694 | -74.148861 | SO2 | ugm3 | 1 | 2,023 | 3.8 | 29,827.29 | 7,801 | 89.0 | 0 | 0.00 | 2.4 | 19.3 | 84.6 | 14/10/2023 8:00 | 0 | 2023-01-12 03:00:00 - 2023-01-12 06:00:00 - 2023-01-26 13:00:00 - 2023-01-26 14:00:00 - 2023-07-04 15:00:00 - 2023-07-21 13:00:00 - 2023-08-22 03:00:00 - 2023-08-22 04:00:00 - 2023-08-22 05:00:00 - 2023-08-22 06:00:00 - 2023-09-03 03:00:00 - 2023-09-03 04:00:00 - 2023-09-03 06:00:00 - 2023-09-23 06:00:00 - 2023-10-10 23:00:00 - 2023-10-11 00:00:00 - 2023-11-28 20:00:00 - 2023-11-28 21:00:00 - 2023-11-28 22:00:00 - 2023-11-28 23:00:00 - 2023-12-19 23:00:00 - 2023-12-20 00:00:00 - 2023-12-20 01:00:00 | 0 | 11 | Bogotá, D.C. | 11001.0 | Bogota, D.C. | Fija | POINT (-74.148861 4.667694) |
| 28731 | 31,876 | SDA | MÓVIL FONTIBÓN | 4.667694 | -74.148861 | SO2 | ugm3 | 24 | 2,023 | 3.8 | 1,254.87 | 329 | 90.0 | 0 | 0.00 | 3.2 | 11.2 | 21.5 | 18/11/2023 0:00 | 0.5 | 22/08/2023 0:00 | 0 | 11 | Bogotá, D.C. | 11001.0 | Bogota, D.C. | Fija | POINT (-74.148861 4.667694) |
Duplicate rows
Most frequently occurring
| ID Estacion | Autoridad Ambiental | Estación | Latitud | Longitud | Variable | Unidades | Tiempo de exposición (horas) | Año | Promedio | Suma | No. de datos | Representatividad Temporal | Excedencias limite actual | Porcentaje excedencias limite actual | Mediana | Percentil 98 | Máximo | Fechas/horas del máximo | Mínimo | Fechas/horas del mínimo | Días de excedencias | Código del Departamento | Nombre del Departamento | Código del Municipio | Nombre del Municipio | Tipo de Estación | Ubicacion | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 19,566 | CAR | COLEGIO RAQUIRA | 5.537468 | -73.635 | NO2 | ugm3 | 24 | 2,011 | 24.8 | 3,547.68 | 143 | 79.0 | 0 | 0.00 | 24.5 | 45.8 | 48.3 | 24/12/2011 | 6.4 | 21/01/2011 | 0 | 15 | BOYACÁ | 15600.0 | RÁQUIRA | Fija | POINT (-73.63499965 5.5374681) | 2 |
| 1 | 19,566 | CAR | COLEGIO RAQUIRA | 5.537468 | -73.635 | NO2 | ugm3 | 24 | 2,012 | 34.6 | 4,984.72 | 144 | 79.0 | 0 | 0.00 | 35.1 | 53.6 | 57.6 | 6/04/2012 | 13.6 | 31/01/2012 | 0 | 15 | BOYACÁ | 15600.0 | RÁQUIRA | Fija | POINT (-73.63499965 5.5374681) | 2 |
| 2 | 19,566 | CAR | COLEGIO RAQUIRA | 5.537468 | -73.635 | NO2 | ugm3 | 24 | 2,014 | 13.6 | 1,267.15 | 93 | 25.0 | 0 | 0.00 | 13.5 | 14.1 | 16 | 2/01/2014 | 12.8 | 20/11/2014 | 0 | 15 | BOYACÁ | 15600.0 | RÁQUIRA | Fija | POINT (-73.63499965 5.5374681) | 2 |
| 3 | 19,566 | CAR | COLEGIO RAQUIRA | 5.537468 | -73.635 | NO2 | ugm3 | 24 | 2,015 | 14.1 | 4,584.11 | 325 | 89.0 | 0 | 0.00 | 14.1 | 14.7 | 14.7 | 10/03/2015 - 22/04/2015 - 18/05/2015 - 27/08/2015 - 01/09/2015 - 03/09/2015 - 15/09/2015 - 16/09/2015 - 19/09/2015 - 12/12/2015 - 17/12/2015 | 13.3 | 12/11/2015 | 0 | 15 | BOYACÁ | 15600.0 | RÁQUIRA | Fija | POINT (-73.63499965 5.5374681) | 2 |
| 4 | 19,566 | CAR | COLEGIO RAQUIRA | 5.537468 | -73.635 | NO2 | ugm3 | 24 | 2,016 | 13.6 | 776.89 | 57 | 16.0 | 0 | 0.00 | 13.5 | 14.1 | 14.1 | 21/01/2016 - 11/02/2016 | 13.2 | 04/01/2016 - 16/01/2016 - 30/01/2016 - 14/02/2016 | 0 | 15 | BOYACÁ | 15600.0 | RÁQUIRA | Fija | POINT (-73.63499965 5.5374681) | 2 |
| 5 | 19,566 | CAR | COLEGIO RAQUIRA | 5.537468 | -73.635 | PM10 | ugm3 | 1 | 2,016 | 108.1 | 797,172.4827 | 7,376 | 84.0 | 0 | 0.00 | 94 | 206 | 852 | 14/06/2016 2:00 | 29 | 16/07/2016 14:00 | 0 | 15 | BOYACÁ | 15600.0 | RÁQUIRA | Fija | POINT (-73.63499965 5.5374681) | 2 |
| 6 | 19,566 | CAR | COLEGIO RAQUIRA | 5.537468 | -73.635 | PM10 | ugm3 | 1 | 2,017 | 46 | 251,511.3859 | 5,468 | 62.0 | 0 | 0.00 | 45.8 | 123.8 | 199.4 | 8/09/2017 7:00 | 0 | 10/06/2017 12:00:00 - 12/06/2017 01:00:00 - 01/07/2017 11:00:00 - 01/07/2017 15:00:00 - 02/07/2017 09:00:00 | 0 | 15 | BOYACÁ | 15600.0 | RÁQUIRA | Fija | POINT (-73.63499965 5.5374681) | 2 |
| 7 | 19,566 | CAR | COLEGIO RAQUIRA | 5.537468 | -73.635 | PM10 | ugm3 | 1 | 2,018 | 45.7 | 313,821.3716 | 6,870 | 78.0 | 596 | 8.68 | 32 | 167.8 | 447.3 | 15/06/2018 19:00 | 3.5 | 29/04/2018 1:00 | 97 | 15 | BOYACÁ | 15600.0 | RÁQUIRA | Fija | POINT (-73.63499965 5.5374681) | 2 |
| 8 | 19,566 | CAR | COLEGIO RAQUIRA | 5.537468 | -73.635 | PM10 | ugm3 | 1 | 2,019 | 49.8 | 400,197.4489 | 8,034 | 92.0 | 1543 | 19.21 | 38.1 | 164.1 | 361.6 | 8/10/2019 4:00 | 2.7 | 18/01/2019 08:00:00 - 01/06/2019 11:00:00 | 251 | 15 | BOYACÁ | 15600.0 | RÁQUIRA | Fija | POINT (-73.63499965 5.5374681) | 2 |
| 9 | 19,566 | CAR | COLEGIO RAQUIRA | 5.537468 | -73.635 | PM10 | ugm3 | 1 | 2,020 | 50.3 | 412,909.715 | 8,204 | 93.0 | 1642 | 20.01 | 39.3 | 156.2 | 590 | 7/02/2020 1:00 | 2.5 | 16/11/2020 12:00 | 240 | 15 | BOYACÁ | 15600.0 | RÁQUIRA | Fija | POINT (-73.63499965 5.5374681) | 2 |